
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
How to find the information you need</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="connpbp3.htm">Previous</A>&nbsp;&nbsp;<A HREF="connpbp5.htm" >Next</A>
<!-- End Header -->
<A NAME="X-REF307042202"></A><h1>How to find the information you need</h1>
<A NAME="TI57"></A><p>When you work with PowerBuilder, you can connect to a database
in the development environment or in an application script.</p>
<A NAME="TI58"></A><p>This book describes how to connect to your database in the PowerBuilder development
environment. </p>
<A NAME="TI59"></A><p>For information about connecting to a database
in a PowerBuilder application script, see <i>Application
Techniques</i>
.</p>
<A NAME="BABHHFGD"></A><h4>Basic connection procedure</h4>
<A NAME="TI60"></A><p>The following table gives an overview of the connection procedure
and indicates where you can find detailed information about each
step.</p>
<A NAME="BABGGFDG"></A><table cellspacing=0 cellpadding=6 border=1 frame="void" rules="all"><caption>Table 1-1: Basic
connection procedure</caption>
<tr><th  rowspan="1"  ><A NAME="TI61"></A>Step</th>
<th  rowspan="1"  ><A NAME="TI62"></A>Action</th>
<th  rowspan="1"  ><A NAME="TI63"></A>Details</th>
<th  rowspan="1"  ><A NAME="TI64"></A>See</th>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI65"></A>1</td>
<td  rowspan="1"  ><A NAME="TI66"></A>(Optional) Get an introduction to database connections
in PowerBuilder</td>
<td  rowspan="1"  ><A NAME="TI67"></A>If necessary, learn more about how PowerBuilder connects
to a database in the development environment</td>
<td  rowspan="1"  ><A NAME="TI68"></A>Chapter 1 (this chapter)</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI69"></A>2</td>
<td  rowspan="1"  ><A NAME="TI70"></A>Prepare to use the data source or database
before connecting to it for the first time in PowerBuilder</td>
<td  rowspan="1"  ><A NAME="TI71"></A>Outside PowerBuilder, install the required
network, database server, and database client software and verify
that you can connect to the database</td>
<td  rowspan="1"  ><A NAME="TI72"></A><i>For ODBC data sources</i>: <A HREF="connpbp10.htm#CCJDCHGF">Chapter 2, "Using the ODBC Interface"</A><A NAME="TI73"></A><p><i>For JDBC data sources</i>: <A HREF="connpbp16.htm#CJACCFCF">Chapter 3, "Using the JDBC Interface"</A></p><A NAME="TI74"></A><p><i>For OLE DB data sources</i>: <A HREF="connpbp20.htm#BJBDAAFF">Chapter 4, "Using the OLE DB Interface"</A></p><A NAME="TI75"></A><p><i>For ADO.NET data sources</i>: <A HREF="connpbp24.htm#BJBDAAFFN">Chapter 5, "Using the ADO.NET Interface"</A></p><A NAME="TI76"></A><p><i>For native database interfaces</i>: <A HREF="connpbp30.htm#CCJDCECH">Chapter 6, "Using Native Database Interfaces"</A></p></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI77"></A>3</td>
<td  rowspan="1"  ><A NAME="TI78"></A>Install the ODBC driver, OLE DB data
provider, ADO.NET data provider, or native database interface</td>
<td  rowspan="1"  ><A NAME="TI79"></A>Install the driver, database provider,
or native database interface required to access your data</td>
<td  rowspan="1"  ><A NAME="TI80"></A>For a list of what is supported on your
platform: "Supported Database Interfaces" in online
Help</td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI81"></A>4</td>
<td  rowspan="1"  ><A NAME="TI82"></A>Define the data source (ODBC connections
and some OLE DB drivers)</td>
<td  rowspan="1"  ><A NAME="TI83"></A>Create the required configuration for
a data source accessed through ODBC </td>
<td  rowspan="1"  ><A NAME="TI84"></A><i>For ODBC data sources</i>: <A HREF="connpbp10.htm#CCJDCHGF">Chapter 2, "Using the ODBC Interface"</A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI85"></A>5</td>
<td  rowspan="1"  ><A NAME="TI86"></A>Define the database interface</td>
<td  rowspan="1"  ><A NAME="TI87"></A>Create the database profile</td>
<td  rowspan="1"  ><A NAME="TI88"></A><i>For ODBC data sources</i>: <A HREF="connpbp10.htm#CCJDCHGF">Chapter 2, "Using the ODBC Interface"</A><A NAME="TI89"></A><p><i>For JDBC data sources</i>: <A HREF="connpbp16.htm#CJACCFCF">Chapter 3, "Using the JDBC Interface"</A></p><A NAME="TI90"></A><p><i>For OLE DB data sources</i>: <A HREF="connpbp20.htm#BJBDAAFF">Chapter 4, "Using the OLE DB Interface"</A></p><A NAME="TI91"></A><p><i>For ADO.NET data sources</i>: <A HREF="connpbp24.htm#BJBDAAFFN">Chapter 5, "Using the ADO.NET Interface"</A></p><A NAME="TI92"></A><p><i>For native database interfaces</i>: <A HREF="connpbp30.htm#CCJDCECH">Chapter 6, "Using Native Database Interfaces"</A></p><A NAME="TI93"></A><p><i>For PowerBuilder components</i>: <A HREF="connpbp101.htm#BJBDAAFG">Chapter 15, "Making Database Connections
in PowerBuilder Components"</A></p></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI94"></A>6</td>
<td  rowspan="1"  ><A NAME="TI95"></A>Define the <ACRONYM title = "E A Server" >EAServer</ACRONYM> connection</td>
<td  rowspan="1"  ><A NAME="TI96"></A>Create an <ACRONYM title = "E A Server" >EAServer</ACRONYM> profile</td>
<td  rowspan="1"  ><A NAME="TI97"></A><A HREF="connpbp101.htm#BJBDAAFG">Chapter 15, "Making Database Connections
in PowerBuilder Components"</A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI98"></A>7</td>
<td  rowspan="1"  ><A NAME="TI99"></A>Connect to the data source or database</td>
<td  rowspan="1"  ><A NAME="TI100"></A>Access the data in PowerBuilder</td>
<td  rowspan="1"  ><A NAME="TI101"></A><A HREF="connpbp82.htm#CCJDAIDF">Chapter 12, "Managing Database Connections"</A></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI102"></A>8</td>
<td  rowspan="1"  ><A NAME="TI103"></A>(Optional) Set additional connection
parameters</td>
<td  rowspan="1"  ><A NAME="TI104"></A>If necessary, set DBParm parameters and
database preferences to fine-tune your database connection and take advantage
of DBMS-specific features that your interface supports</td>
<td  rowspan="1"  ><A NAME="TI105"></A><i>For procedures</i>: <A HREF="connpbp89.htm#BABGFFIB">Chapter 13, "Setting Additional Connection Parameters"</A><A NAME="TI106"></A><p><i>For DBParm descriptions</i>: <br>online
Help</p><A NAME="TI107"></A><p><i>For database preference descriptions</i>: <br>online
Help</p></td>
</tr>
<tr><td  rowspan="1"  ><A NAME="TI108"></A>9</td>
<td  rowspan="1"  ><A NAME="TI109"></A>(Optional) Troubleshoot the data connection</td>
<td  rowspan="1"  ><A NAME="TI110"></A>If necessary, use the trace tools to
troubleshoot problems with your connection</td>
<td  rowspan="1"  ><A NAME="TI111"></A><A HREF="connpbp95.htm#CCJCDEGE">Chapter 14, "Troubleshooting Your Connection"</A></td>
</tr>
</table>

